﻿CREATE TABLE [Perf].[Facts](
	[date_id] [int] NOT NULL,
	[perfmon_id] [int] NOT NULL,
	[sampled_data] [float] NOT NULL,
	[min_deviation_pct] [tinyint] NOT NULL,
	[max_deviation_pct] [tinyint] NOT NULL,
 CONSTRAINT [PK_factData] PRIMARY KEY CLUSTERED 
(
	[date_id] ASC,
	[perfmon_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
) ON [PRIMARY]
GO